UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XYvdGZr43e4pU2nVkF2pBmJhmnla3DWVjuAmH5ZOSVc='
WHERE
key_id = 'c9762231ae09d3abf57c3e1b9181f75c415588fc2a939e20842e2e71d8b0a436'
AND (
token = 'XYvdGZr43e4pU2nVkF2pBmJhmnla3DWVjuAmH5ZOSVc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)