UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lcLW7fW7TDuf+fVhNHWA4ucmv/kpaMHT3RI3kZMs6/E='
WHERE
key_id = '0d86c53caad8a2d78fb170c8ba76e9f9fb502347a64ae7170183294a83ff9970'
AND (
token = 'lcLW7fW7TDuf+fVhNHWA4ucmv/kpaMHT3RI3kZMs6/E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)