UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c1bvEeJ9iTy/xKiOAeUOAWRH80xbSe/YwVIjBiKr5Z8='
WHERE
key_id = 'b8cb083bf3fa83831d35ccc848f6e2be8fbf7a0a33f52a477f63127dfc597d54'
AND (
token = 'c1bvEeJ9iTy/xKiOAeUOAWRH80xbSe/YwVIjBiKr5Z8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)