UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HKQEnRgIcTmVcj8ldlzReVdl+2hgJq4WI8M7+CUGxN0='
WHERE
key_id = 'b1912d64545256cd935b23a2be8b7f57ccdcd55a7a8a5b2991eed2a631f0185a'
AND (
token = 'HKQEnRgIcTmVcj8ldlzReVdl+2hgJq4WI8M7+CUGxN0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)