UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C5z0L/nT7cB1gyYiXs5nRZs2tT6d/lDU/pcTK1kwKjg='
WHERE
key_id = 'a5a8e7c3eb54535ded6b7d6e56126fe9b123402fc70dc9980b364b013145faeb'
AND (
token = 'C5z0L/nT7cB1gyYiXs5nRZs2tT6d/lDU/pcTK1kwKjg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)