UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bhArZE+iZd+GLVpUUyxnJihD8Fl/lTb7bT/z4k+QbiE='
WHERE
key_id = '4d479d70e41013c68ff4572eca6197ef4f2d0a6b00691642712a11c81a422bf4'
AND (
token = 'bhArZE+iZd+GLVpUUyxnJihD8Fl/lTb7bT/z4k+QbiE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)