UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oPbhpIbq4rmR7vRB2QSHzACLpDkif/Gv32JqgmANJoA='
WHERE
key_id = '8a767a00770b80f760eeac01e3ca68647fecc3fee9cbfd96b37b0e2ff8d6bed8'
AND (
token = 'oPbhpIbq4rmR7vRB2QSHzACLpDkif/Gv32JqgmANJoA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)