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