UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lw77chCUgsRZ+gJFEZaYPUidSgBggiI2xdp+wLszgVc='
WHERE
key_id = 'aa20044393574e1dfd510af058f94ee50383b2855d4704fa100217d9a1df7a19'
AND (
token = 'lw77chCUgsRZ+gJFEZaYPUidSgBggiI2xdp+wLszgVc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)