UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BVd/SE+G4KoXInaKJzSZN0wZK062OMqlf2I9ng19l3w='
WHERE
key_id = '852d4def48d22678c059492801358dfe5d711645c9a148c701b4cfc4c2b30d7e'
AND (
token = 'BVd/SE+G4KoXInaKJzSZN0wZK062OMqlf2I9ng19l3w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)