UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LWpIoeHbD49iIEXtn8460YtR18jk+nhEIzmu9LRZiWU='
WHERE
key_id = 'd65d6e84bb7ae62b863d4b3d1ce4a062cf991956dff761c8cd774b30d875c2a7'
AND (
token = 'LWpIoeHbD49iIEXtn8460YtR18jk+nhEIzmu9LRZiWU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)