UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5BU4wdz2arsqX7ie/I17y094+YPFm1Ao9U+qiAhkHYU='
WHERE
key_id = 'ea37fa1e7c4f4c22dce8e7ad39b826f0919c942ef3421bbdb4159758a58f3198'
AND (
token = '5BU4wdz2arsqX7ie/I17y094+YPFm1Ao9U+qiAhkHYU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)