UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BG8+4IcrHAkBvHo/pIx4aPHbv4ecb77TfVDu8S8ImoI='
WHERE
key_id = '45496710a2027f830f22ff45084650a708c523c52c09a21079d0ee2bbe631db3'
AND (
token = 'BG8+4IcrHAkBvHo/pIx4aPHbv4ecb77TfVDu8S8ImoI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)