UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'leTlv0hagt0sRJ+s6BC1P0hBfTjzXyg4AQLmZKk4cpg='
WHERE
key_id = '4cf1903fc7bc8cb760d51ef111a9ab9c4172e396585c4042cba9fd0b5a23b57a'
AND (
token = 'leTlv0hagt0sRJ+s6BC1P0hBfTjzXyg4AQLmZKk4cpg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)