UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yi0oICq3hFAc94y00BtT50aL+/XoNQ0ZYlOehN7Sf2g='
WHERE
key_id = '331f725bd674802f33397c290310375d75c085d2b4301b6dd02bc2ac7323193f'
AND (
token = 'yi0oICq3hFAc94y00BtT50aL+/XoNQ0ZYlOehN7Sf2g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)