UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dplhijRcgF6KADsM/NqWmmvg26TxYAGwyNSm/Jr1+1g='
WHERE
key_id = 'cc47f1572b90ebcac7a95dfb7ee3c7404bce310be8fc33b88bb37efe5ee9803f'
AND (
token = 'dplhijRcgF6KADsM/NqWmmvg26TxYAGwyNSm/Jr1+1g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)