UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0SMbk7RgFOqBOiyVnuYb3/dzZW7pymq1z31zmkeBqac='
WHERE
key_id = 'a075fc742020f1f78aac2c7654b01c46c2431fc9a31165267b19e62e483e01c0'
AND (
token = '0SMbk7RgFOqBOiyVnuYb3/dzZW7pymq1z31zmkeBqac='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)