UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zZV12v3ybgFCmW5WHBl5wmmEhzHVSV3NDNPbfVwn5+E='
WHERE
key_id = 'afbc0b26b48ce375393ac3ef6a01a7232c6370e61655f706a8a2cff24ef3f64c'
AND (
token = 'zZV12v3ybgFCmW5WHBl5wmmEhzHVSV3NDNPbfVwn5+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)