UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kGVwgMatEe0NAqRISZaKDazl23pkfM+VwTSXu7OkWSs='
WHERE
key_id = 'c37f857536d1417032df2987040585102d28c2b4c165e425041b14c3200166ec'
AND (
token = 'kGVwgMatEe0NAqRISZaKDazl23pkfM+VwTSXu7OkWSs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)