UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J73mZbbABqcM5tLVchhPPK6U1E4S6UTgcGy2k5XNDhM='
WHERE
key_id = 'c05b9526dd35324b4f2c6cc70c399b32b53fbe4fea30eda1ddeb0dfbf189751a'
AND (
token = 'J73mZbbABqcM5tLVchhPPK6U1E4S6UTgcGy2k5XNDhM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)