UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OEs4jxWYZ9x9vLKH3olm+/1IiwysvS7oTtS5aRk4Wqg='
WHERE
key_id = 'f3659b0f4b67467df87b5b03cce134ebd95537d2a7ee433b0a16a772d035a669'
AND (
token = 'OEs4jxWYZ9x9vLKH3olm+/1IiwysvS7oTtS5aRk4Wqg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)