UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xezv9GcSBMC4R0F1tHBMdniA0Iw1rcSbbvD+TtXocUg='
WHERE
key_id = '2dcbb6996699678c1ffcd9694cf0245d1167753df5044413d29b60d0ec8b94dd'
AND (
token = 'Xezv9GcSBMC4R0F1tHBMdniA0Iw1rcSbbvD+TtXocUg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)