UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Tk2LK9ebFwpFONJAm1LSsEpsvigHO229QOLWqBCF7+k='
WHERE
key_id = '0b86f00896441893a527aef8e9359a8a6773ccaf8e29269ce71555d59dbc9406'
AND (
token = 'Tk2LK9ebFwpFONJAm1LSsEpsvigHO229QOLWqBCF7+k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)