UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sPplAcZZvpTY1iYYslihiJtZ5xGLW7w1GeNzot1KvkU='
WHERE
key_id = '24f0e28b2daa6f2403dbd8a45f8f5e2a1687c5f6a00e54f0dc6bcb2b58ff4eea'
AND (
token = 'sPplAcZZvpTY1iYYslihiJtZ5xGLW7w1GeNzot1KvkU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)