UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+8HDrkZaB2mTr+PdJo+0XYtF3TTRsGv+P9oObgJclJw='
WHERE
key_id = 'ea3104fb476aba90c2d697b51abfe70878adc9c0585e25c1b3e49b7dd1216bb6'
AND (
token = '+8HDrkZaB2mTr+PdJo+0XYtF3TTRsGv+P9oObgJclJw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)