UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e2iClFDbpEWS5cn+PhNIZZjv7y+S4/fyWwsAurC3cHA='
WHERE
key_id = '3795a3c8539f49c0b687a533f3757084f1f39df26e3147af7897ec5743497c2f'
AND (
token = 'e2iClFDbpEWS5cn+PhNIZZjv7y+S4/fyWwsAurC3cHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)