UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6YibiOtOY68z4soi5X/c4pkF9dauJJA9btm4Ii0Fi3g='
WHERE
key_id = 'fd122cb5bdcb9b39caa5d587d44213678fd38e05b06ad975aa7241ba587040a0'
AND (
token = '6YibiOtOY68z4soi5X/c4pkF9dauJJA9btm4Ii0Fi3g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)