UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4SgaEos2k7syuA95d/oP0iMP3fKRJAbSWL8AbI8r320='
WHERE
key_id = 'f701167b9598af5ad88d42ea7d0cb910e11a428b95aa9801b6e5eaeb5daf5943'
AND (
token = '4SgaEos2k7syuA95d/oP0iMP3fKRJAbSWL8AbI8r320='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)