UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5Z5bCNFLktwJEotFgHLYhoOD6ylbeszJo96Uu6NEISU='
WHERE
key_id = '3bac87ee301bb6cbda6360c6080c085273ea34eae90154c46911eb5a94c1f6c6'
AND (
token = '5Z5bCNFLktwJEotFgHLYhoOD6ylbeszJo96Uu6NEISU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)