UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xj5JGG+4uhbXvljAvpqn05kJui4rq+llsKnMV5uKKhE='
WHERE
key_id = 'b9b2f6d480995c0f5e4d128c8b8383035c3d75799d1a7b9b355180da40f3568a'
AND (
token = 'Xj5JGG+4uhbXvljAvpqn05kJui4rq+llsKnMV5uKKhE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)