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