UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ss++prehLCWoo6kSzclFkvxLqHRMyybMKxBkKylo3c='
WHERE
key_id = 'fa9b30ac517e767ad42b07a4429c060ab2584cc1ae8c57f4f26ed208a8c4938f'
AND (
token = '8ss++prehLCWoo6kSzclFkvxLqHRMyybMKxBkKylo3c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)